<%@ page import="java.sql.Connection" %>
<%@ page import="java.sql.PreparedStatement" %>
<%@ page import="java.sql.ResultSet" %>
<%@ page import="com.example.demo2.DBUtil" %>
<%@ page language="java" contentType="text/html; charset=UTF-8"
		 pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
	<head>
		<meta charset="utf-8">
		<title>Insert title here</title>
		<link rel="stylesheet" type="text/css" href="css/rest.css"/>
		<style type="text/css">
			body{width: 100%;height: 100%;}
			*{margin: 0;padding: 0;}
				.bjt{background:radial-gradient(#6f4351,#40325b);width: 100%;height: 120px;}
				.huixiang{width: 200px;height: 80px;position: absolute;left: 0px;top: 10px;}
				.ziti{font-size: 25px;font-style: italic;font-family: 宋体;color:#91b5ff ;font-weight: 600;position: absolute;left:180px;top: 44px;}
				li{float: left;font-size: 22px;padding: 10px;margin-left: 60px;color: aqua;}
				.liebiao{position: absolute;left: 300px;top: 35px;}
				.zixuankuang{font-size: 12px;color: gray;width: 210px;height:38px;position: absolute;left: 1100px;top: 38px;border-radius: 50px;}
				.sousuo{width: 40px;height: 38px;position: absolute;left: 1274px;top: 40px;border-radius: 50px;background-color: dimgray;}
				li>a{color: white;}
				.si{background-color: black;height: 300px;position: relative;top: 2000px;}
				.c1{font-size: 18px;font-weight: 300;color: white;position: absolute;left: 450px;top: 50px;}
				.c1-1{color: red;}
				.c2{font-size: 18px;font-weight: 300;position: absolute;left: 520px;top:80px;color: white;}
				.c3{font-size: 18px;font-weight: 300;color: white;position: absolute;left: 600px;top:120px;}
				.c4{height: 40px;width: 130px;position: absolute;left: 580px;top:180px;}
				.c5{height: 40px;width: 130px;position: absolute;left: 740px;top:180px;}
				.c6{height: 40px;width: 130px;position: absolute;left: 900px;top:180px;}
				
				.bd1{width: 50px;height: 50px;background-color: red;color: white;font-style: italic;font-size: 30px;text-align: center;line-height: 50px;}
				.bd1-1{height: 220px;width:1000px ;border: solid 1px gray;    display: flex;
					margin-left: 5%;
				}
				.bd1-1-1{width: 160px;height: 220px;}
				.bd1-2{font-size: 30px;}
				.bd1-3{font-size: 20px;margin: 5% 0;}
				.bd1-4{font-size: 20px;color: gray;}
				.bd1-5{font-size: 60px;font-style: italic;color: orange;}
				
				.bd2{width: 50px;height: 50px;background-color: orchid;color: white;font-style: italic;font-size: 30px;text-align: center;margin-left: -100px;line-height: 50px;margin-top: 200px;}
				.bd2-1{height: 220px;width:1000px ;border: solid 1px gray;position: absolute;top: 350px;}
				.bd2-1-1{width: 160px;height: 220px;}
				.bd2-2{position: absolute;top: 50px;left: 200px;font-size: 30px;}
				.bd2-3{position: absolute;top: 100px;left: 200px;font-size: 20px;}
				.bd2-4{position: absolute;top: 140px;left: 200px;font-size: 20px;color: gray;}
				.bd2-5{position: absolute;top: 70px;left: 850px;font-size: 60px;font-style: italic;color: orange;}
				
				.bd3{width: 50px;height: 50px;background-color: palegreen;color: white;font-style: italic;font-size: 30px;text-align: center;margin-left: -100px;line-height: 50px;margin-top: 200px;}
				.bd3-1{height: 220px;width:1000px ;border: solid 1px gray;position: absolute;top: 350px;}
				.bd3-1-1{width: 160px;height: 220px;}
				.bd3-2{position: absolute;top: 50px;left: 200px;font-size: 30px;}
				.bd3-3{position: absolute;top: 100px;left: 200px;font-size: 20px;}
				.bd3-4{position: absolute;top: 140px;left: 200px;font-size: 20px;color: gray;}
				.bd3-5{position: absolute;top: 70px;left: 850px;font-size: 60px;font-style: italic;color: orange;}
				
				.bd4{width: 50px;height: 50px;background-color: paleturquoise;color: white;font-style: italic;font-size: 30px;text-align: center;margin-left: -100px;line-height: 50px;margin-top: 200px;}
				.bd4-1{height: 220px;width:1000px ;border: solid 1px gray;position: absolute;top: 350px;}
				.bd4-1-1{width: 160px;height: 220px;}
				.bd4-2{position: absolute;top: 50px;left: 200px;font-size: 30px;}
				.bd4-3{position: absolute;top: 100px;left: 200px;font-size: 20px;}
				.bd4-4{position: absolute;top: 140px;left: 200px;font-size: 20px;color: gray;}
				.bd4-5{position: absolute;top: 70px;left: 850px;font-size: 60px;font-style: italic;color: orange;}
				.denglu>a{color: white;}
				.bd5{width: 50px;height: 50px;background-color:mistyrose;color: white;font-style: italic;font-size: 30px;text-align: center;margin-left: -100px;line-height: 50px;margin-top: 200px;}
				.bd5-1{height: 220px;width:1000px ;border: solid 1px gray;position: absolute;top: 350px;}
				.bd5-1-1{width: 160px;height: 220px;}
				.bd5-2{position: absolute;top: 50px;left: 200px;font-size: 30px;}
				.bd5-3{position: absolute;top: 100px;left: 200px;font-size: 20px;}
				.bd5-4{position: absolute;top: 140px;left: 200px;font-size: 20px;color: gray;}
				.bd5-5{position: absolute;top: 70px;left: 850px;font-size: 60px;font-style: italic;color: orange;}
				a>.bd1-5:hover {transform: scale(1.5,1.5);}
				a>.bd2-5:hover {transform: scale(1.5,1.5);}
				a>.bd3-5:hover {transform: scale(1.5,1.5);}
				a>.bd4-5:hover {transform: scale(1.5,1.5);}
				a>.bd5-5:hover {transform: scale(1.5,1.5);}
				
		</style>
	</head>
	<body>
		<div class="bjt">
			<div class="si">
				<div class="c1">关于悦享汇：<span class="c1-1">关于我们	| 管理团队 | 投资者关系 |</span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;友情链接：<span class="c1-1">美团网 | 美团下载 | 欢喜首映 |</span></div>
				<div class="c2">QQ邮箱：2112633811.com&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;客服电话：152425125</div>
				<div class="c3">悦享汇用户服务协议 |			悦享汇平台交易规则总则 | 			隐私政策 |</div>
				<img src="img/C9.png"class="c4" >
				<img src="img/C8.png"class="c5" >
				<img src="img/C7.png"class="c6" >
				</div>
			<img src="img/R-C.png" class="huixiang">
			<div class="ziti">悦享汇电影</div>
			<div class="liebiao">
				<ul>
				<li><a href="shouye.jsp">首页</a></li>
				<li><a href="dianying.jsp">电影</a></li>
				<li><a href="yingyuan.jsp">影院</a></li>
				<li><a href="bangdan.jsp">榜单</a></li>
				<li><a href="redian.jsp">热点</a></li>
				<li><a href="shangcheng.jsp">商城</a></li>
			</ul>
			</div>
			<%@include file="sousuo.jsp"%>
			<%@include file="dl.jsp"%>

		
		
		<%
			Connection cn = null;
			PreparedStatement ps = null;
			ResultSet rs = null;
			String sql = "";
			cn = DBUtil.getConnection();
			sql = "select * from list limit 0,5";
			ps = cn.prepareStatement(sql);
			rs = ps.executeQuery();
			while(rs.next()){
				int pm_id = rs.getInt("pm_id");
				int number = rs.getInt("number");
				Double Score = rs.getDouble("Score");
				String name = rs.getString("name");
				String date = rs.getString("date");
				String img = rs.getString("img");
				String Starring = rs.getString("Starring");
		%>
			<div style="width: 100%;
				display: flex;
				justify-content: center;
				height: 220px;
				margin-top: 3%;
				align-items: center;">
				<div class="bd1"><%=pm_id%>	</div>
				<a href="">
					<div class="bd1-1">
						<img src="<%=img%>" class="bd1-1-1">
						<div style="display: flex;
							justify-content: space-between;
							align-items: center;
							width: 75%;
							margin-left: 3%;
						">
							<div>
								<div class="bd1-2"><%=name%></div>
								<div class="bd1-3">
									主演：<%=Starring%>
								</div>
								<div class="bd1-4">
									上映时间：<%=date%>
								</div>
							</div>
							<div class="bd1-5"><%=Score%></div>
						</div>
					</div>
				</a>
			</div>
		<%
			}
		%>

		</div>
	</body>
</html>
